Closed World Databases Opened Through Null Values

نویسندگان

  • Georg Gottlob
  • Roberto V. Zicari
چکیده

We propose a new approach to the treatment of nullvalued attributes in the relational model. The approach is based on the new concept of locally-controlled open world database. A locally-controlled open world dab base permits the definition of portions of a traditional closed world database as open-world. Attributes, part of a relation, or entire relations can be explicitly defined as ‘open” through the insertion of null-values. Under this assumption, we consider three different types of null values: the standard unknown, does not e&t, and the new one, called open. We give a complete formal specification of the semantics of these null values. We extend the arithmetic and logical operators to cover nulls and outline how relational operators cau be extended accordingly. This paper describes ongoing work. We state some open problems to be solved iu order to render our approach more operational

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Completeness in the Relational Model: a Comprehensive Framework

Completeness is a well known data quality dimension in the area of databases. Intuitively, a database is complete if it represents every fact of the real world coherent with the database semantics, i.e. its intension. In the paper, we provide a comprehensive framework for characterizing completeness in the relational model, investigating several different paradigms typical of database models, s...

متن کامل

STRESS INTENSITY FACTORS FOR AN INTERIOR GRIFFITH CRACK OPENED BY HEATED WEDGE IN A STRIP WHOSE EDGES ARE NORMAL TO CRACK AXIS

After second world war, we have seen a very rapid development of Thermoelasticity stimulated by various engineering sciences. As we know, structures behave in different fashion under climate variation and the most responsible factor for these variations is heat which falls through and causes deformation of the body. A considerable progress in the field of aircraft and machine structures, mainly...

متن کامل

The problem of missing data in geoscience databases

SQL is the (more or less) standardised language that is used by the majority of commercial database management systems. However, it is seriously flawed, as has been documented in detail by Date, Darwen, Pascal, and others. One of the most serious problems with SQL is the way it handles missing data. It uses a special value ‘NULL’ to represent data items whose value is not known. This can have a...

متن کامل

Adaptive-clustering Based Method to Estimate Null Values in Relational Databases

Data preprocessing is an essential step of knowledge discovery. Data preprocessing comprises data cleaning, data integration, data transformation, data reduction and data discretization. Estimating null values is a task of data cleaning. Null values in a database are significant sources of poor data quality. Therefore, the appropriate handling of null values is an important task of data preproc...

متن کامل

Containment of Conjunctive Queries over Databases with Null Values

We study containment of conjunctive queries that are evaluated over databases that may contain tuples with null values. We assume the semantics of SQL for single block queries with a SELECT DISTINCT clause. This problem (“null containment” for short) is different from containment over databases without null values and sometimes more dif-

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1988